How will you copy the structure of a table without copying the data?

Question

Shekhar Kumar · Answer

There is one method for copying the structure of
tableand without copying the data is
SELECT * INTO NewTable FROM OldTable Where 1=2

Chris Anderson · Answer

There is one method for copying the structure of tableand without copying the data is
create tableand NEWTABLEand as select * from OLDTABLE where 1=2

interview

How will you copy the structure of a table without copying the data?

Chris Anderson

Can you answer this question?

2 Answers

Liked By